﻿SET QUOTED_IDENTIFIER ON
GO
SET ARITHABORT ON
GO
SET NUMERIC_ROUNDABORT OFF
GO
SET CONCAT_NULL_YIELDS_NULL ON
GO
SET ANSI_NULLS ON
GO
SET ANSI_PADDING ON
GO
SET ANSI_WARNINGS ON
GO

CREATE PROCEDURE [dbo].[bhp_SetPageByFunctionality]
(
	@Function	NVARCHAR(400),
	@PageId		INT = 1
)
AS
BEGIN

	INSERT INTO bht_PagesFunctionality
		SELECT PageID, @Function FROM mp_Pages WHERE PageID = @PageId

END
GO
